package aiku.numericalcontroloa.Mapper;

import aiku.numericalcontroloa.Model.Entity.Clients;
import aiku.numericalcontroloa.Model.Entity.ClientsExpansion;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.time.LocalDate;
import java.time.YearMonth;
import java.util.Collection;
import java.util.List;

/**
* @author 马
* @description 针对表【clients】的数据库操作Mapper
* @createDate 2024-01-26 09:49:58
* @Entity aiku.numericalcontroloa.Model.Entity.ClientsController
*/
@Mapper
public interface ClientsMapper extends BaseMapper<Clients> {

    /**
     * 根据id列表查询已删除的
     * @param clientsIdList
     * @return
     */
    List<Clients> selectBatchByIdWithDelete(@Param(value = "list") Collection<String> clientsIdList);

    /**
     * 查询已删除的
     * @param id
     * @return
     */
    Clients selectByIdWithDelete(@Param(value = "id") String id);

    /**
     * 查询排名
     * @param localDate
     * @param yearMonth
     * @param type
     * @return
     */
    List<ClientsExpansion> selectRanking(@Param(value = "day")LocalDate localDate,
                                         @Param(value = "month")YearMonth yearMonth,
                                         @Param(value = "type")Integer type);
}




